Course: Tableau Data Visualization and Analytics
Learning Objective: Understand the purpose of Rows and Columns shelves, learn how to place dimensions and measures on them, interpret discrete and continuous fields, and create meaningful charts using Tableau.
Course Link: JustAcademy Tableau Training
Demo Link: Register for a Tableau Course Demo
In Tableau, Rows and Columns are important shelves used to organize data and define the structure of a visualization. They determine how fields appear in the worksheet and how Tableau arranges headers, axes, panes, and marks.
The Rows shelf generally controls the vertical arrangement of a view, while the Columns shelf generally controls the horizontal arrangement. By placing fields on these shelves, users can create bar charts, line charts, tables, heat maps, and many other visualizations.
Tableau allows users to drag fields from the Data pane and drop them onto either shelf. The resulting view depends on the field type, its discrete or continuous setting, and the combination of fields used.
Suppose a company wants to analyze sales across different product categories. You can place Category on Columns and Sales on Rows. Tableau can then display a chart showing the sales associated with each category.
Data Pane
|
|-- Category ------> Columns Shelf
|
|-- Sales ---------> Rows Shelf
|
v
Sales by Category VisualizationThe Rows shelf is an area in a Tableau worksheet where you place fields to organize information vertically. Depending on the field, Tableau may create row headers, a vertical axis, or additional sections within the view.
Assume a dataset contains four regions: East, West, North, and South. Dragging the Region field to Rows creates row headers for those regions.
| Region | Sales |
|---|---|
| East | 25,000 |
| West | 32,000 |
| North | 18,000 |
| South | 28,000 |
When Region is placed on Rows and Sales is placed on Columns, Tableau can create a horizontal bar chart comparing sales by region.
The Columns shelf is an area in a Tableau worksheet where fields are placed to organize information horizontally. It can create column headers, a horizontal quantitative axis, or separate columns and panes within a visualization.
If the Category field contains Furniture, Office Supplies, and Technology, placing it on Columns creates a separate column header for each category.
| Furniture | Office Supplies | Technology |
|---|---|---|
| Sales data | Sales data | Sales data |
When Category is on Columns and Sales is on Rows, Tableau can display a vertical bar chart comparing sales across categories.
| Feature | Rows Shelf | Columns Shelf |
|---|---|---|
| General orientation | Vertical organization | Horizontal organization |
| Discrete dimension | Typically creates row headers | Typically creates column headers |
| Continuous measure | Typically creates a vertical axis | Typically creates a horizontal axis |
| Common use | Listing categories or displaying vertical measures | Displaying categories across a view or horizontal measures |
| Example | Region on Rows | Category on Columns |
| Chart orientation | Can contribute to vertical bar charts or horizontal category lists | Can contribute to horizontal bar charts or vertical category comparisons |
Important: Rows does not always mean that a chart will be horizontal, and Columns does not always mean that a chart will be vertical. Chart orientation depends on the fields, their properties, and the resulting view configuration.
To use Rows and Columns effectively, you need to understand the difference between dimensions and measures.
Dimensions are fields used to categorize, group, or describe data. They commonly contain names, labels, dates, or categories.
Examples: Region, Category, Product Name, Customer Name, Order Date, and Segment.
When a discrete dimension is placed on Rows or Columns, Tableau generally creates headers representing its members.
Measures are fields containing values that can usually be measured or aggregated, such as sales, profit, quantity, or cost.
Examples: Sales, Profit, Quantity, Discount, and Revenue.
When a continuous measure is placed on Rows or Columns, Tableau generally creates a quantitative axis. Tableau commonly aggregates measures using functions such as SUM, AVG, MIN, or MAX.
| Field | Typical Type | Example Use |
|---|---|---|
| Region | Dimension | Place on Rows to list regions |
| Category | Dimension | Place on Columns to compare categories |
| Sales | Measure | Place on Rows or Columns to show values |
| Profit | Measure | Compare profitability across groups |
| Order Date | Date field; can be used discretely or continuously | Analyze sales over time |
One of the most important concepts when working with Rows and Columns is the difference between discrete and continuous fields.
Discrete fields represent separate, distinct values. In Tableau, discrete field pills are generally blue. They typically produce headers rather than a continuous numeric axis.
Examples: Region names, product categories, individual years displayed as headers, and customer segments.
Continuous fields represent values along a range. In Tableau, continuous field pills are generally green. They typically create an axis with a continuous scale.
Examples: Sales values, profit values, and dates displayed on a continuous timeline.
| Feature | Discrete | Continuous |
|---|---|---|
| Typical pill color | Blue | Green |
| Appearance | Headers for distinct members | Continuous axis or scale |
| Common purpose | Group and separate categories | Show magnitude, range, or progression |
| Example | Category | SUM(Sales) |
A field's behavior depends on how it is configured in the view. For example, a date field can be displayed as discrete date parts or as a continuous timeline.
Follow these steps to create your first visualization using the shelves.
You should see a view comparing sales across product categories. The exact chart type and appearance depend on the field configuration and Tableau's automatic choices.
Business Question: Which product category generates the highest sales?
| Category | Sales |
|---|---|
| Furniture | 45,000 |
| Office Supplies | 30,000 |
| Technology | 60,000 |
Technology has the highest sales in this sample, followed by Furniture and Office Supplies. The visualization helps the viewer compare category performance quickly.
Business Question: Which region contributes the most sales?
Result: Region names appear as row headers, while the sales values are represented along the horizontal axis. This layout is useful when category names are long or many categories need to be compared.
Business Question: How do sales change from month to month?
Result: The horizontal axis represents time, and the vertical axis represents sales. This view helps identify trends, increases, decreases, and recurring patterns.
Tip: If Tableau groups January from multiple years together, check whether the date field is using month as a date part rather than a month-and-year timeline. Use the date level that best represents the intended analysis.
A cross-tab presents summarized values in a row-and-column arrangement. It is useful when users need exact figures instead of a chart.
| Region | Furniture | Office Supplies | Technology |
|---|---|---|---|
| East | 12,000 | 8,000 | 18,000 |
| West | 15,000 | 10,000 | 22,000 |
| North | 9,000 | 7,000 | 11,000 |
The figures above are illustrative. In Tableau, the values shown are calculated from the connected dataset and the aggregation used.
Tableau allows multiple fields to be placed on the Rows and Columns shelves. This adds detail to a view and can create nested headers, additional panes, or more complex visualizations.
The view can show sales broken down by region and then category. The order of fields on a shelf affects the structure and level of detail of the view.
When multiple fields occupy a shelf, Tableau uses their order to organize headers and panes. Moving a field can change the nesting of categories and make the visualization easier or harder to interpret.
Practical tip: Experiment with field order and check the result after each change. Keep the most useful grouping structure for the business question.
You can move a field from one shelf to the other to change the layout of a visualization.
For example, moving Region from Rows to Columns changes where region headers appear. Moving a measure between shelves can change the orientation of the quantitative axis and the chart.
To remove a field, drag its pill off the shelf or use the field's menu and choose the available removal option. In Tableau Desktop, you can also clear a shelf using its context menu.
Drag field pills into the desired order on the same shelf. Tableau updates the view to reflect the new order.
Rows and Columns shelves work together with other elements of the worksheet.
Adding fields to Rows and Columns can increase the number of headers, panes, and marks. A well-designed view should balance detail with readability.
Rows and Columns establish the structure of a view, while the Marks card controls how data is visually represented within it.
| Element | Purpose | Example |
|---|---|---|
| Rows | Defines vertical structure or a vertical axis | Region or Sales |
| Columns | Defines horizontal structure or a horizontal axis | Category or Order Date |
| Color | Distinguishes marks by a field | Color bars by Region |
| Label | Displays text on marks | Show sales values |
| Size | Changes the size of supported marks | Represent quantity with circle size |
| Detail | Adds detail to the level of the view | Include customer-level detail |
| Tooltip | Shows details when a user points to a mark | Display product and profit details |
Possible reason: The field types, shelf placement, aggregation, or mark type may not match the intended chart.
Solution: Check the fields on Rows and Columns, review the pill menus, and select an appropriate mark type.
Possible reason: Tableau is summing multiple records, or the underlying dataset contains repeated records.
Solution: Check the aggregation and the data structure. Use SUM, AVG, MIN, or MAX only when appropriate for the question.
Possible reason: Several high-cardinality dimensions have been added to the shelves.
Solution: Remove unnecessary fields, use filters where appropriate, or summarize the data at a more useful level.
Possible reason: The date field is using a date part or date level that does not match the analysis.
Solution: Open the date pill menu and choose the desired date level or continuous date option.
Possible reason: Long headers or too many categories make the view crowded.
Solution: Consider a horizontal bar chart, improve formatting, sort categories, or narrow the analysis to relevant items.
Project Goal: Build a Tableau worksheet that compares sales across regions and product categories.
After completing this project, you should be able to create different views by arranging dimensions and measures on Rows and Columns, select suitable field configurations, and explain the results in business terms.
Answer: They are worksheet areas where fields are placed to structure a visualization. Rows generally control vertical organization, while Columns generally control horizontal organization.
Answer: Tableau generally creates row headers for the distinct members of the dimension.
Answer: Tableau generally creates a horizontal quantitative axis for that measure.
Answer: Discrete fields represent distinct members and generally create headers. Continuous fields represent a range and generally create an axis.
Answer: Yes. Multiple fields can be placed on either shelf to create additional headers, panes, and levels of detail.
Answer: The view is reorganized. Headers or axes associated with the field change orientation, and the visualization may change accordingly.
Answer: It controls how marks are represented, including mark type, color, size, label, detail, and tooltip.
Answer: Tableau commonly aggregates measures to summarize records in the view. SUM adds the values in the relevant group, although another aggregation may be more appropriate for some analyses.
Answer: Place the category field on Rows and the measure on Columns, then choose a bar mark if needed.
Answer: Place a suitable Order Date field on Columns, Sales on Rows, and select a line mark.
Answer: Field order affects the arrangement and nesting of headers and panes, which can change how users interpret the data.
Answer: Drag the pill off the shelf or use the field menu to remove it.
Rows and Columns shelves are fundamental building blocks of Tableau visualizations. They allow users to arrange dimensions and measures, define the structure of a view, and explore data from different perspectives. By learning how discrete and continuous fields behave, how multiple fields interact, and how shelf placement works with the Marks card, you can create clear and informative charts and tables.
Continue learning with JustAcademy Tableau Training, or use Register for a Tableau Course Demo to explore the course.
